package vcp.server.utility;

/**
 * 
 * @author VCP team
 *         <p>
 *         Constants Class for server side
 *         </p>
 */
public class Constants
{
	public static final String IP_ADDRESS = "IP Address";
	public static final String PORT_IS_BUTY = "This port is busy";

	/**
	 * 
	 * @author VCP team table names constants
	 */
	public class TableNames
	{
		public static final String SITE = "vcp.site";
		public static final String SITE_COSTS_UPDATE = "vcp.siteCostsUpdate";
		public static final String LOT = "vcp.lot";
		public static final String WORKER = "vcp.worker";
		public static final String USER = "vcp.user";
		public static final String CUSTOMER = "vcp.customer";
		public static final String SUBSCRIPTION = "vcp.subscriptions";
		public static final String CARS = "vcp.cars";
		public static final String COMPLAINT = "vcp.complaint";
		public static final String COMPLAINT_HISTORY = "vcp.complaintHistory";
		public static final String SUBSCRIPTIONHISTORY = "vcp.subscriptionHistory";
		public static final String PERIODIC_REPORT = "vcp.periodicReport";
		public static final String DAY_STATISTICS = "vcp.dayStatic";
		public static final String WEEKLY_STATISTICS = "vcp.weeklyStatic";
	}

	/**
	 * 
	 * @author VCP team site table constants
	 */
	public class SiteTable
	{
		public static final String SITE_ID = "siteID";
		public static final String COLUMNS = "columns";
		public static final String SITE_NAME = "siteName";
		public static final String DAMAGED_LOTS = "damagedLots";
		public static final String RESERVED_LOTS = "reservedLots";
		public static final String OCCUPIED_LOTS = "occupiedLots";
		public static final String SINGLE_USE_HOUR = "singleUsePricePerHour";
		public static final String ORDER_AHEAD_HOUR = "orderAheadPricePerHour";
		public static final String CASUAL_PRICE = "casualPriceSingleCar";
		public static final String FULL_PRICE = "fullPriceSingleCar";
	}

	/**
	 * 
	 * @author VCP team site costs update table constants
	 */
	public class SiteCostsUpdateTable
	{
		public static final String ID = "updateID";
		public static final String SITE_NAME = "siteName";
		public static final String SINGLE_USE_HOUR = "singleUsePricePerHour";
		public static final String ORDER_AHEAD_HOUR = "orderAheadPricePerHour";
		public static final String CASUAL_PRICE = "casualPriceSingleCar";
		public static final String FULL_PRICE = "fullPriceSingleCar";
		public static final String UPDATE_STATUS = "updateStatus";
		public static final String IS_HISTORY = "isHistory";
	}

	/**
	 * 
	 * @author VCP team lot table constants
	 */
	public class LotTable
	{
		public static final String FLOOR = "lotFloor";
		public static final String ROW = "lotRow";
		public static final String COLUMN = "lotColumn";
		public static final String STATUS = "status";
		public static final String LOT_SITE_ID = "siteID";
		public static final String CAR_ID = "carID";
		public static final String RESERVED_BY_SUBSCRIPTION = "reservedBySubscription";
		public static final String BROKE_START_DATE = "brokeStartDate";
		public static final String BROKE_END_DATE = "brokeEndDate";
	}

	/**
	 * 
	 * @author VCP team user table constants
	 */
	public class UserTable
	{
		public static final String ID = "userID";
		public static final String PASSWORD = "userPassword";
		public static final String FIRST_NAME = "userFirstName";
		public static final String LAST_NAME = "userLastName";
		public static final String TYPE = "userType";
		public static final String EMAIL = "userEmail";
		public static final String IS_LOGGED_IN = "isLoggedIn";
	}

	/**
	 * 
	 * @author VCP team worker table constants
	 */
	public class WorkerTable
	{
		public static final String ID = "workerID";
		public static final String SITE_ID = "siteID";
		public static final String JOB_TYPE = "jobType";
		public static final String DEPARTMENT_NAME = "department";

	}

	/**
	 * 
	 * @author VCP team customer table constants
	 */
	public class CustomerTable
	{
		public static final String ID = "customerID";
		public static final String PHONE = "phoneNumber";
		public static final String BUSSINESS_CLASS = "bussinessClass";
		public static final String BALANCE = "balance";
	}

	/**
	 * 
	 * @author VCP team Subscriptions table constants
	 */
	public class SubscribtionsTable
	{
		public static final String ID = "subscriptionID";
		public static final String CUSTOMER_ID = "customerID";
		public static final String SITE_NAME = "siteName";
		public static final String TYPE = "subscribtionsType";
		public static final String START_DATE = "startDate";
		public static final String END_DATE = "endDate";
		public static final String ESTIMATED_LEAVE_DATE = "estimatedLeaveDate";
		public static final String ARRIVAL_DATE = "arrivalDate";
	}

	/**
	 * 
	 * @author VCP team cars table constants
	 */
	public class CarsTable
	{
		public static final String ID = "carID";
		public static final String CUSTOMER_ID = "customerID";
		public static final String SUBSCRIPTION_ID = "subscriptionID";
		public static final String IS_PARKED_ON_SITE = "isParkedOnSite";
		public static final String ARRIVED_TIME = "arrivedTime";
		public static final String LAST_CHECK_OUT_DATE = "lastCheckOutDate";
	}

	/**
	 * 
	 * @author VCP team complaints table constants
	 */
	public class ComplaintTable
	{
		public static final String ID = "complaintID";
		public static final String CUSTOMER_ID = "customerID";
		public static final String COMPLAINT_TYPE = "complaintType";
		public static final String TEXT = "text";
		public static final String STATUS = "status";
		public static final String OPEN_DATE = "openDate";
		public static final String IS_HISTORY = "isHistory";
		public static final String SITE_NAME = "siteName";
	}

	/**
	 * 
	 * @author VCP team Complaint History table constants
	 */
	public class ComplaintHistoryTable
	{
		public static final String ID = "complaintHistoryID";
		public static final String COMPLAINT_ID = "complaintID";
		public static final String TEXT = "text";
		public static final String RESOLVE_TEXT = "resolveText";
		public static final String RESOLVE_STATUS = "resovleStatus";
		public static final String REFUND_AMOUNT = "refundAmount";
		public static final String CLOSE_DATE = "closeDate";
		public static final String SITE_NAME = "siteName";
	}

	/**
	 * 
	 * @author VCP team Subscription History table constants
	 */
	public class SubscriptionHistoryTable
	{
		public static final String ID = "subscriptionID";
		public static final String CUSTOMER_ID = "customerID";
		public static final String SITE_NAME = "siteName";
		public static final String TYPE = "subscribtionsType";
		public static final String START_DATE = "startDate";
		public static final String END_DATE = "endDate";
		public static final String ARRIVAL_DATE = "arrivalDate";
		public static final String LEAVE_DATE = "leaveDate";
		public static final String IS_CANCELED = "isCanceld";
	}

	/**
	 * 
	 * @author VCP team
	 *         <p>
	 *         Periodic Report Table constants
	 *         </p>
	 */
	public class PeriodicReportTable
	{
		public static final String ID = "reportID";
		public static final String TYPE = "reportType";
		public static final String START_DATE = "startDate";
		public static final String END_DATE = "endDate";
		public static final String SITE = "siteName";
	}

	/**
	 * 
	 * @author VCP team
	 *         <p>
	 *         Day Statistics Table constants
	 *         </p>
	 */
	public class DayStatisticsTable
	{
		public static final String ID = "dayStaticID";
		public static final String NUM_OF_USED_ORDERS = "numberOfUsedOrders";
		public static final String NUM_OF_CANCEL_ORDERS = "numberOfCanceledOrders";
		public static final String NUM_OF_SUBSCRIPTIONS = "numberOfSubscriptions";
		public static final String NUM_OF_BUSSINESS_CLASS = "numberOfBussinessClass";
		public static final String NUM_OF_PARKING_LATE = "numberOfParkingLates";
		public static final String SITE_NAME = "siteName";
		public static final String DATE = "date";
	}

	public class WeeklyStatisticsTable
	{
		public static final String ID = "weekStaticID";
		public static final String START_DATE = "startDate";
		public static final String END_DATE = "endDate";
	}
}
